We outline the topics covered in this lesson as well as what you need to follow along.
The Word Environment
Learn to control the Word screen tools and windows.
Entering and Editing Text
We'll show you how to correct typing errors using standard keyboard and mouse commands.
Saving Files
Learn the proper way to save your work for safekeeping.
Blocking and Manipulating Text
We show you the best way to select and manipulate text. Learn how to cut, copy, and paste text from one area to another.
Spell Check and Thesaurus
In a matter of minutes, you'll produce precise, error-free documents.
Printing Documents
We'll show you how to preview and print hard copy versions of your text documents.
Inserting Graphics
We show you how to enhance your document's appearance and emphasize key points by importing and manipulating graphics.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Exploring the Normal Template
Explore pre-made document templates and the normal template. Learn how they affect your word processing and how to benefit from their use.
Working with Character Formats
Add emphasis to your text. Change your document's appearance with just a few mouse clicks.
Page Formats, Margins and Indents
Manipulate a document's size and orientation. Also learn how to set a document's margins and work with indents.
Aligning Text
We show you how to justify text based on a document's left and right margins.
Working with Tabs
Create lists of text, numbers or both. We'll show you how to apply and change tabs inside a Word document.
Creating and Using Styles
Save time formatting your documents. Learn how to apply a group of formats in one simple step.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Mail Merge Basics
Discover what components are needed to perform mail merges which can be used to do mass mailings.
Editing Fields
Learn how to alter the types of information contained within a data source file as well as the individual pieces of data those fields contain.
Inserting Fields in a Form Letter
Turn a simple letter into a document that can be merged with a database. Learn how to use field codes in the mail merge process to personalize a form letter.
Adding Fields/Performing Sorts
Modify an existing database. Remove unwanted data or add new data. Also learn how to arrange data source information alphabetically or numerically.
Creating Merge Envelopes
Produce an envelope to match every record in your source. Learn how and where field codes should be placed as well as how to enter a return address.
Mail Merges
Produce the final merged document and save it to disc. Also learn how to edit a letter once the merge is complete.
END
Excel 2000
Level 1
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
The Excel Environment
Learn to control the Excel screen environment and its tools. We also teach you how to move to any location on the spreadsheet.
Building a Budget
Have Excel keep track of your personal or business finances. We teach you the proper way to construct a spreadsheet.
Saving Files to disc
Learn the appropriate way to save your files for safekeeping.
Working With Formulas
Save time and increase productivity. We teach you how to build your own formulas as well as apply Excel's pre-defined formulas.
Performing "What-If" Analysis
Discover an electronic spreadsheet's real power. We show you how to take the agony out of making qualified projections and financial analysis.
Formatting
Learn how a few mouse clicks can help you emphasize key points and figures.
Printing
Preview and print the finished product. Discover which options alter what is printed and how it is printed.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Using Multiple Worksheets
We show you how to name spreadsheet pages in addition to copying information between them.
Creating Charts
We show you how to turn boring numbers into an easy-to-read chart.
Manipulating Chart Elements
Learn how to alter the way Excel charts data. We also teach you how to add graphic elements to make your information clearer.
Calculating Income and Expense
Find the perfect mix of quantities and cost. Learn how to read a spreadsheet and determine which product will produce the best portfolio.
Absolute and Relative Cell Addresses
Discover why some formulas always point to a specific cell address, while others change to accommodate a formula's new address.
Revenues, Expenses, and Net Income
Test spreadsheet formulas and perform "what-if" analysis by entering different data.
Creating a Summary Page
Make your financial analysis make sense. We show you how to copy all relevant information onto a single page, complete with documentation, charts and compiled data.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Database Fundamentals
Discover what databases are, what they are used for, and how they can benefit you.
Building a Payroll Database
Learn how to catalog business or personal data such as names, addresses, phone numbers, and product information.
Using the "If" Function
Save time and eliminate data entry. We teach you how to make your database evaluate data for you.
Modifying an Existing Data Table
Learn how to insert columns and records into an existing Excel data table.
Finding Records
Discover how easy it is to find information within a data table no matter how large it is.
Sorting Data
We show you how to reorganize database information, without re-entering data.
Performing Queries
We show you how to filter database information until you find records that match specific criteria.
END
Access 2000
Level 1
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Creating a Database
Forget about Rolodex cards and bulky folders. Learn what a database is and how it can help you organize business contacts, inventory, and a number of personal items.
Creating and Using Tables
We show you how to create database fields and how to modify their properties.
Entering Data into a Table
We simplify the process of entering and copying data into a table. You'll also learn how to create a Lookup field that makes entering data easier and more precise.
Creating and Modifying Forms
Discover the techniques that make it easier for you and others to enter data into a database table. You'll also learn how to manipulate a form's controls to fit a specific mode of operation.
Adding a Field to a Form
Forget something? We show you how to add a new field to an existing table, and then add that to an existing form.
Level 2
Using the Table Wizard
Let Access work for you. We'll show you how to use the pre-made fields in Access to quickly build a table. In addition, you'll learn how to rename those fields to better fit your needs.
Using the Form Wizard
Turn the tedious task of creating a form into a simple step-by-step process.
Create a Table
We'll show you yet another way to create a database table. You'll also learn how to resize columns.
Table Relationships
The real power of a relational database is its ability to link database tables together so you can access information more quickly. We'll show you how the power of linking can benefit you.
Create Queries
Databases aren't just for storing data. They also allow you to extract specific data -- if you know how to ask. We'll show you how to phrase your questions in a language Access understands.
Using Queries in Forms
We show you how to combine multiple database objects to enhance a form's ability to retrieve information quickly.
Create and Modify Reports
Even the most organized data needs a little help conveying the information you desire. In this section, you'll learn how to make your database make sense to others.
Queries with Multiple Tables
Only rarely is the information you seek all in one database object. We show you how to select and combine information from different sources to get the right results.
Create Custom Reports
We teach you how to create a report from scratch. After viewing this section, you'll be able to modify any report created in Access.
Level 3
Introduction
We will have a quick look at what lies ahead in Access Level 3.
Importing Data into an Access Database
In this lesson, we'll learn how to import files from external sources, such as Excel or dBase. During this process, we'll also learn how to exclude fields, set field properties, and set primary keys within the imported tables.
Using the Find Duplicates Query Wizard
We'll show you how to search several tables to find the duplicate records between them. Learn how to create and copy an Input Mask, and develop table relationships so we can build powerful queries.
Select Queries vs. Action Queries
You will learn the difference between Select Queries and Action Queries. Once you understand what an Action Query is, we'll create one. As you do that, you'll learn how to set advanced query criteria.
Linking Tables Between Two Databases
You will learn how to link tables between databases and the many benefits of doing so.
Using a Union Query
You will learn how to create a union query, one of the most powerful tools in Access. Furthermore, we will give you a glimpse of the SQL programming behind the scenes that makes this Query work.
END
PowerPoint 2000
Level 1
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
PowerPoint Environment
We help you make sense of all those icons, toolbars, and menus. You'll discover the ease in which a few commands can change the way you view your presentation.
Entering and Modifying Text
PowerPoint makes creating custom slides easy. We show you how to enter and edit text as well as apply formats that make your text come alive.
Adding, Deleting and Arranging Slides
Conveying your message in a clear, concise manner takes more than flashy graphics and well-written headings; it takes planning. We show the tools that help you do that.
Viewing Your Presentation
We will show you the tools to use once your slides are done and you are ready to show your presentation, whether it is a sales presentation or pictures from your last vacation.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Using Text Boxes and AutoShapes
Add life to your slides. Discover the ease in which you can create and modify your own placeholders. Also, learn how to turn a few shapes into an eye-catching graphic.
Using the Slide Sorter
It pays to take a step back to see the big picture. Using the Slide Sorter View, you can do that and much more. We show you how to move, add, or delete slides from your presentation.
Working with the Clip Art Gallery
If a picture is worth a thousand words, then PowerPoint's Clip Gallery is worth its weight in gold. We show you how to find images that add visual impact and clarity to your presentation.
Checking Your Presentation
Don't let embarrassing typos and gaudy formatting ruin your presentation. We show you the tools to help find spelling errors and prevent inconsistencies in displayed information.
Adding Speaker Notes
It is time to deliver the presentation. We show you the tools to help you communicate more effectively with your audience.
Level 3
Introduction
We will tell you what you will learn by watching this Video Professor lesson, and how those skills fit in with those you've learned in our earlier PowerPoint lessons.
Creating a Chart
Charts allow your viewers to understand your data quickly and give your presentation credibility. In this section, we show you how to make and modify charts in PowerPoint.
Importing Charts
When data has been compiled in another application, there is no need to repeat the work. Simply import it into your PowerPoint presentation. We show you how it is done.
Managing a Presentation's Look
In this section, you will learn how to create an effective visual environment. We show you the tools that you can use in PowerPoint and how to implement them.
Using the Slide Master
To facilitate continuity between slides, PowerPoint allows us to add, delete, and modify slide elements that appear throughout our presentation with one easy-to-use tool: the Slide Master.
END
Quicken 2002
Level 1
Introduction
You will see the set up and lesson requirements for Quicken 2000 and get an overview of this lesson.
Creating a Data File
You will learn how to setup your accounts in Quicken.
The Quicken Layout
We will show you how to lay out the components of the Quicken screens.
Working with the Check Register
You will learn how to enter checks, deposits, and their related information using Quicken's electronic register.
Editing the Category List
Have Quicken track your finances. Create any category of expense or income so you can designate how your money is being spent.
Recording Split Transactions
You'll see how Quicken tracks where your money is coming from and where it is going.
Creating and Printing Checks
Say goodbye to expensive check and bank service charges. We show you how to write and print your own checks.
Reconciling Your Bank Statement
No need to wonder where the extra zero went. See how Quicken turns this dreaded end-of-the-month chore into a few mouse clicks.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Using My Finances
Quicken's My Finances page displays all your Quicken data in one easy-to-read place. We show you how to use its options as well as modify them to meet your needs.
Working with a Credit Card Account
We show you how to track your credit card expenses. In addition, you'll learn how to pay credit card bills by transferring funds between accounts.
Scheduled Transactions
We show you how to eliminate typing and guess work. We'll also set up automatic deposits and payments.
Setting Up a Loan
Perform your own financial analysis. With Quicken, you can plan for the future or work out the details of a loan you need today.
Exploring the Planning Center
We will see where your money goes and how it's working for you. We will show you how to keep track of payments, interest paid, and the transfer of funds.
Reports and Graphs
See how to create reports and graphs that define your financial status.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Connecting to the Internet
To do online banking, Quicken needs to be setup to use your Internet Service Provider. See how this is done.
Setting Up an Online Checking Account
We will set up an online checking account with a bank and see how that account works with Quicken.
Setting Up Online Payees
We show you how to enter payment information for online payees so the bank will know where to send the payment.
Making Online Payments
We'll show you how to enter online banking information and schedule transactions into the Quicken check register.
Connecting to an Online Bank Account
We will show you how to send and receive online banking information.
Working with an Investment Account
Tracking your investments is important. You will see how to setup investment accounts in Quicken.
Working with the Investment Register
You will learn how the investment register works and how to edit it to keep track of your investments.
Using Portfolio View
Learn how to go online and download the latest information concerning your investments and market performance.
Investment Research
Learn how to go online and check on your investments. Let Quicken help you track stocks and mutual funds to see how they are performing.
END
Windows 98
Level 1
Introduction
Learn what a computer system is comprised of and how it processes information. Discover the types of hardware and functions they serve.
Computer Components
Learn about the components that make up your computer, and the task each one performs.
The Desktop Interface
Learn how Windows 98 controls your computer. Understand the elements of your computer screen layout and how to use them.
Elements of a Window
Each window that opens in this program has many elements that control the window and the programs that run within it.
Menus and Toolbars
Each window opens with menus and toolbars specific to the program running in that window. Learn what they are and how to view the toolbars you want to use.
The Taskbar
Discover the desktop tools that provide quick and easy access to every application on your system.
The Start Button
Every program and utility on your computer can be accessed from the Start menu. See how this works to start programs, open documents, and change your computer's configuration.
File Folders and Saving Documents
Windows 98 has its own organizational system for storing and displaying everything on your computer. Learn how this system works as you save a file to the desired location.
The Control Panel
The Control Panel houses all of the system hardware controls and custom settings you can apply to your computer.
Level 2
Introduction
We outline what the lesson will teach and how it plans on conveying that message.
Using the Find Command
Never be at a loss when it comes to "misplaced" files. We show you quick and efficient ways to track down files on any storage device.
Files and Folders
Organize your files. Discover the ease with which you can create file folders on your floppy disc and other storage locations.
Creating a Shortcut
Learn how to create and modify shortcuts that allow quick access to files, folders and programs.
Working with the Applets
Windows '98 comes with its own word processor. We show you how to use it to create an "eye-catching" announcement.
Using the Paint Program
We teach you how to draw lines and shapes, select foreground and background colors, and more. You'll also learn how to transfer information from one program to another.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Using the Utilities
Improve your computer's performance. You'll learn how to use the Windows '98 disc maintenance utilities that help your computer run smoothly and rid your hard drive of unnecessary files.
Add/Remove Windows Components
Discover the ease with which programs can be added or deleted from your system. We walk you through installing the "Backup" program, one of many "add-on" components that come with Windows '98.
Backing Up Files
We show you how to take the worry out of a system meltdown. You'll learn how to backup your files for safekeeping.
Multimedia Options
Discover how to play audio and video files in addition to controlling your system's multimedia programs. We also show you how to play music CDs and program their play lists.
Creating Custom Toolbars
We show you how to create a custom toolbar, where any program, folder or file can be a mouse click away.
END
Windows ME
Level 1
Introduction
Learn what a computer system is comprised of and how it processes information. Discover the types of hardware and functions they serve.
Inside Your Computer
Learn about the components that make up your computer and the task each one performs.
The Desktop Interface
Learn how Windows ME controls your computer. Understand the elements of your computer screen layout and how to use them.
Elements of a Window
Each window that opens in this program has many elements that control the window and the programs that run within it.
Contents of a Window
Every window has menus, toolbars, scroll bars and a workspace to help you accomplish your goal. Learn where they are and how to use them.
The Taskbar
Discover the desktop tools that provide quick and easy access to every application on your system.
The Start Button
Every program and utility on your computer can be accessed from the Start menu. See how this works to start programs, open documents, and change your computer's configuration.
Files, Folders and Saving Documents
Windows ME has its own organizational system for storing and displaying everything on your computer. Learn how this system works as you save a file to the desired location.
The Control Panel
The Control Panel houses all of the system hardware controls and custom settings you can apply to your computer.
Level 2
Introduction
We outline what the lesson will teach and how it plans on conveying that message.
Using the Find Command
Never be at a loss when it comes to "misplaced" files. We show you quick and efficient ways to track down files on any storage device.
Files and Folders
Organize your files. Discover the ease with which you can create file folders on your floppy disc and other storage locations.
Creating a Shortcut
Learn how to create and modify shortcuts that allow quick access to files, folders and programs.
Working with the Applets
Windows ME comes with its own word processor. We show you how to use it to create an eye-catching announcement.
Using the Paint Program
We teach you how to draw lines and shapes, select foreground and background colors, and more. You'll also learn how to transfer information from one program to another.
Level 3
Introduction
Find out what you'll learn in this spectacular lesson from Video Professor. Use Folder Options to learn about your settings.
Using the Maintenance Wizard
Learn how to improve your system's performance and schedule routine check-ups to keep it running smoothly.
Add/ Remove Programs
Learn how to install programs using the ADD/REMOVE feature in Windows ME and take a brief tour of the Control Panel.
Using Backup
Understand the value of backing up your data and exactly how to do it.
System Restore
Discover a new Windows ME feature called System Restore and how it can save you time and panic in case of a system crash or freeze. Set it up so it works for you.
Multimedia Options
Tour the magic of the Multimedia Player and learn to control your music and video files as they play.
END
Windows XP
Level 1
Introduction
Learn what a computer system is comprised of and how it processes information. Discover the types of hardware and functions they serve.
Computer Components
Learn about the components that make up your computer and the task each one performs.
The Desktop Interface
Learn how Windows controls your computer. Understand the elements of your computer screen layout and how to use them.
Elements of a Window
Each window that opens in this program has many elements that control the window and the programs that run within it.
Contents of a Window
Every window has menus, toolbars, scroll bars, and a workspace to help you accomplish your goal. Learn where they are and how to use them.
The Taskbar
Discover the desktop tools that provide quick and easy access to every application on your system.
The Start Button
Every program and utility on your computer can be accessed from the Start menu. See how this works to start programs and change your computer's configuration.
File Folders and Saving Documents
Windows has its own organizational system for storing and displaying everything on your computer. Learn how this system works as you save a file to the desired location.
The Control Panel
The Control Panel houses all of the system hardware controls and custom settings you can apply to your computer.
Level 2
Introduction
We outline what the lesson will teach.
Using the Search Command
Never be at a loss when it comes to "misplaced" files. We show you quick and efficient ways to track down files on any storage device.
Files and Folders
Organize your files. Discover the ease with which you can create file folders on your floppy disc and other storage locations.
Creating a Shortcut
Learn how to create and modify shortcuts that allow quick access to files, folders, and programs.
The Windows Explorer Program
See the ultimate place to view and manipulate your files and folders. We'll also create a project folder to place on the Desktop.
Working with WordPad
Windows comes with its own word processor. We show you how to use it to create an "eye-catching" announcement.
Using the Paint Program
We teach you how to draw lines and shapes, select foreground and background colors, and more. You'll also learn how to transfer information from one program to another.
Level 3
Introduction
Find out what you'll learn in this spectacular lesson from Video Professor. Use Folder Options to learn about your settings.
Using the System Tools
Learn how to improve your system's performance and do routine check-ups to keep it running smoothly.
Add / Remove Programs
Learn how to install programs using the ADD / REMOVE feature in Windows and take a brief tour of the Control Panel.
Using Backup
Understand the value of backing up your data and exactly how to do it.
System Restore
Discover this Windows feature called System Restore and how it can save you time and panic in case of a system crash or freeze. Set it up so it works for you.
Multimedia Options
Tour the magic of the Multimedia Player and learn to control your music and video files as they play.
END
WordPerfect 9
Level 1
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
The WordPerfect Environment
Learn to control the WordPerfect screen tools and windows.
Entering and Editing Text
We'll show you how to correct typing errors using standard keyboard and mouse commands.
Saving, Opening and Closing Files
Learn the proper way to save your work for safekeeping. Open and close documents using a variety of methods.
Blocking and Manipulating Text
We show you the best ways to select and manipulate text. Learn how to cut, copy, and paste text from one area to another.
Spell Check and Thesaurus
In a matter of minutes, you'll produce precise, error-free documents.
Printing
Preview and print hard copy versions of your WordPerfect documents.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Inserting Graphics
We show you how to enhance your document's appearance and emphasize key points by importing and manipulating graphics.
Initial Style and Formatting
The Initial Style gives us a starting point for each new document. Learn how it affects text and how you can tailor it to fit your needs.
Reveal Codes
Avoid format conflicts. Learn how WordPerfect controls where a format begins and where it ends.
Page Formats and Margins
We teach you how to change your document's page size and orientation as well as the spacing between document text.
Line Spacing Formats
Control a document's spatial arrangement. We teach you how to manipulate the distance between each line of text.
Indents and Tabs
Learn how to align text by setting left indents, double indents, and hanging indents. Discover how tabs are used to align text and numbers.
Working with Styles
Save formatting time by saving existing formats under a Style name. Once created, a style's formats can be instantly applied to any text.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Merge Basics
Learn how easy it is to create hundreds of personalized letters. Discover what databases are, what they are used for, and how they can benefit you. We'll show you how to create and edit your own database.
The Form File
Turn a simple letter into a document that can be merged with a data file. Learn what field codes are and how you can use them to eliminate data entry.
Performing the Merge
We show you how to combine database information with the form file to create a finished document. You will learn how to insert new text into the form file as well as edit out any unwanted information.
Working with TextArt and Watermarks
Enhance your documents by using text as a graphic element. Then build on your graphic skills by using a graphic object as a watermark for the background of your document.
Performing Sorts/Creating Envelopes
We show you how to reorganize database information alphabetically or numerically. We'll also produce an envelope to match each record in the database.
END
Learn the Internet
Level 1
Introduction
Learn which topics will be covered in this lesson.
History of the Internet
Understand the history of the Internet,how the Internet can be used, and learn what a domain name is.
Exploring the Home Page
Navigate your way around the Yahoo Home Page and discover its many features.
Customizing the Home Page
Learn how to personalize your Home Page to display the information you want to see.
Exploring the Internet
Use search engines to surf the web, add your favorite web sites to quickly return to them, and customize the Weather Channel for your local forecast.
E-mail for Outlook Express
Find out how to send, receive, and manage e-mail using the Outlook Express e-mail program.
Level 2
Introduction
Learn which topics will be covered in this lesson.
Microsoft Internet Explorer
Customize Internet Explorer to suit your preferences, find out what an Internet ôcookieö is, and see how to save time online.
Security and Viruses
Protect your identity, your financial information, and your computerÆs contents from falling into the wrong hands!
Online Privacy Protection
Learn how to keep your family safe from undesirable content on the Internet.
Instant Messenger and Chat Rooms
What is faster than overnight delivery or e-mail? Instant Messaging and Chat Rooms! WeÆll show you how to use two of the most popular instant message features on the Internet.
Sharing Information on the Web
Communicate with groups that share your same interests, and find information and opinions on just about any topic.
Level 3
Introduction
Learn which topics will be covered in this lesson.
Buying on the Internet
Visit several popular e-commerce sites and learn the process of buying and selling things online.
Customizing a Stock Portfolio
Create a custom stock portfolio, and track and follow any companyÆs stock price.
Downloading Programs
Learn how to download programs from the Internet, and use the popular compression and archival utility WinZip.
Downloading Files and Graphics
Use Internet search techniques to find files and graphics, then take the steps needed to place these files and images into a document.
Advanced Outlook Express E-mail
Use spell check and formatting to improve your messages, and add attachments to your e-mail using Outlook Express.
END
Works 2000
Level 1
Introduction
We outline the topics covered in the lessons as well as what you will need to follow along.
The Works Word Processing Screen
Learn how to control the Works windows and its screen tools.
Entering and Editing Text
We show you how to correct typing errors using keyboard and mouse commands.
Saving Files and Text Formatting
Learn the proper way to save your work for safekeeping.
Working with Clip Art and WordArt
We show you how to add art to your pages and change text into art.
Headers/Footers and Spell Check
Discover how to make information, such as page numbers and addresses, appear on every page of your document. Also, we'll teach you how to produce error free and well-read documents.
Creating a Database
Forget about Rolodex cards and bulky folders. Learn how to catalog business or personal data such as names, addresses, phone numbers and product information.
Entering Records
We show you how to input and edit database data to create records.
Mail Merge
We show you how to merge your database information with a letter.
Level 2
Introduction
We outline the topics covered in the lessons as well as what you will need to follow along.
Adding Database Fields
We'll show you how to modify an established Works database field. Also, learn how to copy information from one Works database table to another.
Using a Database for Statistics
Learn how to keep your data records organized to sort later or query the data to find specific information.
Database Formulas and Formatting
Learn how to combine the storage capabilities of a Works data table with the calculating power of a spreadsheet. Also learn how to format a data table to emphasize key information.
Sorting Records
Learn how to reorganize the stored data within a database, either alphabetically or numerically.
Finding Records and Using Filters
Locate records based on simple criterion within a data table. Also learn how to apply filters to a data table to find records that match a single parameter or multiple parameters.
Creating a Report
Summarize your database information so it is easy to read. We show you how to perform database operations and produce a summary report in one easy operation.
Building a Spreadsheet
Get the spreadsheet skills that allow you to track personal finances as well as perform business analysis.
Working with Formulas
Save time and increase productivity. Discover how to build your own formulas as well as use some of Works' pre-made formulas.
Formatting a Spreadsheet
Learn how a few mouse clicks can help you emphasize key points and figures.
Level 3
Introduction
We outline the topics covered in the lessons as well as what you will need to follow along.
Creating Charts
Make your numbers make sense. Turn your spreadsheet numbers into easy-to-read charts.
Chart Formatting
We show you how to alter the way Works charts your spreadsheet data. Plus, we show you how a new formatting tool can make your charts easier to read.
Spreadsheet and Chart Printing
Discover the techniques that allow you to print only selected parts of a spreadsheet. In addition, we teach you the details of printing charts.
Adding Rows to a Spreadsheet
We show you where a row or column should be inserted and what happens to your spreadsheet when they are added.
Using Templates and Task Wizards
Let Works do the work for you. Learn how answering a few questions can produce a 'ready-made' document, saving hours of formatting time.
Saving Files as Templates
Learn the steps that turn a regular document into a template on which other documents can base their look and formatting.
Using the Works Calendar
We show you how to keep your appointments, schedule, and other events organized and on track.
END
Outlook 2000
Level 1
Introduction
We outline the topics covered in this lesson as well as what you will need to follow along.
Setting Up Outlook
There are several ways to set up Outlook 2000. We will show you what each option involves and teach you how to configure Outlook to work best with Video Professor's lesson.
The Outlook Environment
We will give you a quick tour of the different areas of Outlook and inform you of what each area is used for.
E-mail Basics
Learn the basic principles of the most common form of communication over the Internet -- e-mail.
Advanced E-mail
We show you how to reply to and forward messages from your Inbox. Also learn how to use the Address Book and send e-mails to multiple recipients.
Customizing E-mail
Discover how to attach files and indicate importance as well as how to format e-mail and personalize with stationery. Also learn other custom features useful in this version of Outlook.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you will need to follow along.
Contacts
The Rolodex comes into the electronic age. Keep all of your personal and professional contacts' addresses and phone numbers handy in this central location.
The Calendar
Organize all of your day's activities. The Calendar feature helps you plan meetings and keep track of all of your appointments.
The Task Pad
Say goodbye to keeping that paper "to-do" list in your pocket. Outlook's Task Pad helps you remember what you need to get done.
The Journal
If you need to keep a record of which documents you worked on and for how long, the Journal section of Outlook can automatically track your use of all Office documents.
Notes
Clean up your desk of all those little yellow sticky notes. Use Outlook's Notes feature to jot quick thoughts and reminders that stay open even without running Outlook.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you will need to follow along.
Using Folders
Outlook stores information in several folders. We will create and organize folders, and then show you how to work with the folder list to copy and move data between them.
Locating Information and QuickFind
Looking for a specific e-mail or contact reference? You'll learn the fastest and easiest way to search Outlook for whatever you may need.
Organize Features of Outlook
Keep track of several different folders of information at once. We'll show you how to create Rules to have Outlook automatically sort information for you.
Importing/Exporting Data
Learn how Outlook can import information from other applications. Also learn how to share data by exporting a "Personal Folder" file for others to access.
Sharing Information
If several people need access to information on your computer, sharing a folder can be the easiest way to keep others up-to-date on the current status of a project.
END
Outlook 2002
Level 1
Introduction
We outline the topics covered in this lesson as well as what you will need to follow along.
Setting Up Outlook
There are several ways to set up Outlook. We will show you what each option involves and teach you how to configure Outlook to work best with Video Professor's lesson.
The Outlook Environment
We will give you a quick tour of the different areas of Outlook and explain what each area is used for.
E-mail Basics
Learn the basic principles of the most common form of communication over the Internet -- e-mail.
Advanced E-mail
We show you how to reply to and forward messages from your Inbox. Also learn how to send e-mail to multiple recipients.
Address Book
Make an electronic version of your 'Little Black Book'. Keep the addresses of people to whom you frequently send messages stored for quick retrieval.
Sending E-mail Attachments
Send files with your e-mail messages such as a document to your boss or a picture to a friend.
Customizing E-mail
Discover how to flag messages as important, as well as how to format e-mail, personalize messages with stationery, and other custom features in Outlook.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you will need to follow along.
Creating Contacts
The Rolodex comes into the electronic age. Keep all of your personal and professional contacts' addresses and phone numbers handy in this central location.
Modifying Contacts
Create new contacts from existing information or update a current client. Also, select which layout of your contacts works best for you.
Scheduling Appointments
Organize all of your day's activities. The Calendar feature helps you plan meetings and keeps track of all your appointments.
Recurring Appointments
Schedule the weekly sales meeting in one simple screen. Learn how to modify individual occurrences of recurring meetings. We'll also show you how to mark holidays in your Calendar.
The Task Pad
Say goodbye to keeping that paper "to-do" list in your pocket. Outlook's Task Pad helps you remember what needs to be done.
The Journal
If you need to keep a record of which documents you worked on and for how long, the Journal section of Outlook can automatically track your use of all Office documents.
Notes
Throw away those little yellow sticky notes on your desk. Use Outlook's Notes feature to jot quick thoughts and reminders that stay open even without running Outlook.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you will need to follow along.
Using Folders
Outlook stores information in several folders, so we will create and organize these folders. We will show you how to work with the folder list by copying and moving data between the folders.
Locating Information and QuickFind
Looking for a specific e-mail or contact reference? You'll learn the fastest and easiest way to search Outlook for whatever you may need.
Organize Features of Outlook
Keep track of several different folders of information at once. We'll show you how to create Rules so Outlook can automatically sort information for you.
Importing/Exporting Data
Learn how Outlook can import information from other applications. Also learn how to share data by exporting a "Personal Folder" file for others to access.
Archiving Information
Over time, you will accumulate lots of information. We will show you how to archive older items in Outlook to a backup file and then restore them at a later time.
END
FrontPage 2000
Level 1
Introduction
We outline the topics covered in this lessons as well as what you will need to follow along.
Website Basics
This section is the road map where you will learn about basic website structure and design.
The FrontPage Environment
Explore the FrontPage environment and learn where to find what you will need to build your web.
The Views Bar
The Views Bar is the steering wheel of FrontPage. In this section, you will learn what direction each view will take you.
Exploring Themes
This section offers you an alternative way to design the look and feel of your site.
Creating a Site from Scratch
Learn how to build your site from the ground up using FrontPage.
Shared Borders
Learn the value and simplicity of using Shared Borders in FrontPage.
Level 2
Introduction
Learn what lies ahead in developing the content of your FrontPage web site.
Inserting Images
Images are the key to an attractive site. In this section, learn how to place them in your site and determine whether they will work.
Working with Images
You will use the tools provided by FrontPage to fine tune the visual aspect of your site.
Working with Text
The text on your site provides the information you want viewers to know. In this section you learn how to place text on your pages.
Developing Your Site
Go deeper into the development of a web site and learn some finer points of building a web.
Hyperlinks
Hyperlinks are vital to a good web site. In this section you will learn how to create them in a FrontPage web.
Bookmarks
Find out what Bookmarks are in FrontPage and learn how to apply them to your own site.
Level 3
Introduction
Learn what lies ahead in further developing and fine-tuning the content of your FrontPage web site using more advanced methods.
Creating Tables
Learn how to better lay out your pages using Tables.
Manipulating Tables
You will learn how to adjust your tables to create an attractive and controlled layout.
Frames
Learn what frames are and how to set them up to your advantage in FrontPage.
Publishing Your Site
The moment you've all been waiting for -- learning how to publish your site to the World Wide Web.
END
FrontPage 2002
Level 1
Introduction
Find out what's in store for this lesson and set up your FrontPage environment to begin this lesson.
Web Site Basics
Learn about the basic components and design elements of a web site. Make a plan for your own site.
The FrontPage Environment
Get a tour of the FrontPage environment and learn to use its most useful tools. We also open a template and set it up.
The Views Bar
The Views Bar is the most important organizing tool within the FrontPage environment. Discover the power of this tool and how to use it in this section.
Working with the Template
FrontPage offers a wide range of templates. We'll choose one and teach you how to begin building a site.
Saving in FrontPage
Saving is the most important step in building a web in FrontPage. We'll show you all the ways it can be done.
Level 2
Introduction
Learn what lies ahead in developing the content of your FrontPage web site.
Themes
FrontPage provides a number of options for the look and feel of the site. Find out how to choose and customize your theme so your site has a unique appearance.
Working with Tables
Tables are an excellent layout tool for web pages. Learn about the many ways to place them on the page and use them to make it look good.
Working with Images
Images are key to an attractive site. Learn how to place them in your site and determine whether they will work.
Thumbnails and Anchors
When using images on your site, you will need to know how to apply Thumbnails and Anchors so they work well in your web design. Learn how in this section.
Hyperlinks and Bookmarks
Hyperlinks are vital to a good web site. Learn how to create them in a FrontPage web. Also learn about Bookmarks and how to apply them.
Level 3
Introduction
Find out what lies ahead and what you need to begin.
Shared Borders and Graphics
Learn about the differences between Shared Borders and Frames Pages as well as what they do and how to use them. Learn to build a scrolling Marquee and use a picture for a background.
Working with Frames
Build a Frames page that alternates between a guest book and order form. Then we'll add these pages to our navigation bar and save them.
Adding Custom Forms
Forms are a very useful and common feature on the Web. In this section, we'll build a form from scratch.
Making Forms Function
Making a form work on the Web is complex. We'll show you how to set data entry rules, data retrieval options, and set rules for data collection and review.
Using the Forms Wizard
You can also create and edit a form using the Wizard. In this section we'll use it and make a special "Submit" button. We'll also add a Confirmation Page.
Testing Your Site
It is important to test your site and check your reports to make sure everything will function properly once you publish it. Find out how to make it web ready.
Publishing Your Site
Publishing your web site is very exciting. We will discuss procedures and checklists, go over reports, and see what it will look like in the browser.
END
Access 2002
Level 1
Introduction and Environment
We outline the topics covered in this lesson as well as what you need to follow along. Get a tour of the Access environment and set up your page.
Creating a Database
No more need for a Rolodex and bulky folders. Learn what a database is and how it can help you get organized.
Creating and Using Tables
Tables are the storage unit for all of your database information. We show you how to create database fields in a table and how to modify their properties.
Entering Data into a Table
We simplify the process of entering and copying data into a table. You will also learn how to create a Look-up field that makes entering data easier and more precise.
Creating and Using Forms
Learn how to create and manipulate a form to fit your needs. Forms can make data entry even easier.
Adding a Field to a Form
We show you how to add a new field to an existing table and then add that to an existing form.
Level 2
Using the Table Wizard
We'll find out just how easy Access can be, using the guidance of the Table Wizard. Then we'll learn how to adapt the fields to individual needs.
Using the Form Wizard
Turn the tedious task of producing a form into a creative step-by-step process.
Creating a Table in Datasheet View
There are many ways to build a table. Here we learn how to do it from the Datasheet View.
Table Relationships
One of the most powerful aspects of database development is that relationships can be built between tables. Here we will learn how to develop those relationships.
Creating Queries
Queries show the real power of databases. Learn how to extract the right information by using the right questions.
Using Queries in Forms
We show you how to combine multiple database objects to enhance a form's ability to retrieve information quickly.
Creating and Modifying Reports
Find out what a report is and how to set one up. Then we'll show you how to make changes and make it work for you.
Queries with Multiple Tables
We show you how to gather information from more than one table to get one set of results.
Creating a Custom Report
We teach you how to create a report from scratch. After viewing this section, you'll be able to modify any report created in Access.
Level 3
Introduction
Find out what lies ahead in this lesson and get the files you need.
Importing Data to Access
Access works with many different programs. Find out which ones and how to import data from them and put them to use.
Find Duplicates Query Wizard
Make no mistake -- the Duplicate Wizard will eliminate duplicates. Learn what the results are called and what you can do with them.
Select Queries vs. Action Queries
There are several types of queries. In this section, learn the difference between them. We'll also show you how to set advanced query criteria.
Linking Tables
Linking Tables is a very useful process. Find out why and how to do it.
Using a Union Query
Learn how to pull it all together using a Union Query. Also, catch a glimpse of the SQL programming behind the query scenes.
END
Excel 2002
Level 1
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
The Excel Environment
Learn to control the Excel screen environment and its tools. We also teach you how to move to any location on the spreadsheet.
Building a Budget
Have Excel keep track of your personal or business finances. We teach you the proper way to construct a spreadsheet.
Saving Files to disc
Learn the appropriate way to save your files for safekeeping.
Working with Formulas
Save time and increase productivity. We teach you how to build your own formulas as well as apply Excel's pre-defined formulas.
Performing "What-If" Analysis
Discover an electronic spreadsheet's real power. We show you how to take the agony out of making qualified projections and financial analysis.
Formatting
Learn how a few mouse clicks can help you emphasize key points and figures.
Printing
Preview and print the finished product. Discover which options alter what is printed and how it is printed.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Using Multiple Worksheets
We show you how to name spreadsheet pages in addition to copying information between them.
Creating Charts
We show you how to turn boring numbers into an easy-to-read chart.
Manipulating Chart Elements
Learn how to alter the way Excel charts data. We also teach you how to add graphic elements to make your information clearer.
Calculating Income and Expenses
Find the perfect mix of quantities and cost. Learn how to read a spreadsheet and determine which product will produce the best portfolio.
Absolute and Relative Cell Addresses
Discover why some formulas always point to a specific cell address, while others change to accommodate a formula's new address.
Revenues, Expenses and Net Income
Test spreadsheet formulas and perform "what-if" analysis by entering different data.
Creating a Summary Page
Make your financial analysis make sense. We show you how to copy all relevant information onto a single page, complete with charts and compiled data.
Level 3
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Database Fundamentals
Discover what databases are, what they are used for, and how they can benefit you.
Building a Payroll Database
Learn how to catalog business or personal data such as names, pay rates, and exemptions.
Using the "IF" Function
Save time and eliminate data entry. We teach you how to make your database evaluate data for you.
Modifying an Existing Data Table
Learn how to insert columns and records into an existing Excel data table.
Finding Records
Discover how easy it is to find information within a data table, no matter how large it is.
Sorting Data
We show you how to reorganize database information without re-entering data.
Performing Queries
We show you how to filter database information until you find records that match specific criteria.
END
PowerPoint 2002
Level 1
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
PowerPoint Environment
We help you make sense of all those icons, toolbars and menus. You'll discover the ease in which a few commands can change the way you view your presentation.
Enter and Modify Text
PowerPoint makes creating custom slides extremely easy with the proper tools. One of these powerful tools is the text placeholders. You will learn how to enter and modify text.
Formatting and Enhancing Text
We will show you how to apply formats to make your text come alive. Then we'll look at a unique tool that allows us to copy fancy formatting from one block of text to another.
Using the Outline Pane
You will organize and enter text using the Outline Pane. Conveying your message in a clear, concise manner takes more than flashy graphics and well-written headings; it takes planning.
Viewing Your Presentation
We show you the tools to use once the slides are done and you're ready to show your presentation, whether it is a sales presentation or pictures from your last vacation.
Level 2
Introduction
We outline the topics covered in this lesson as well as what you need to follow along.
Using Text Boxes
Learn how to add life to your slides. Discover the ease in which you can create and modify your text placeholders to emphasize the important points of your presentation.
AutoShape Tools
Learn how to turn a few simple shapes into eye-catching graphics, including "AutoShapes," which are ready-made shapes we can add to our presentation slides.
Using the Slide Sorter View
It pays to take a step back to see the big picture. Using the slide sort view you can do that and much more. We show you how to move, add, or delete from your presentation.
Working with the Clip Art Gallery
If a picture is worth a thousand words, then PowerPoint's Clip Gallery is worth its weight in gold. We show you how to find images to add visual impact and clarity to your presentation.
Checking Your Presentation
Don't let embarrassing typos and gaudy formatting ruin your presentation. We show you the tools that can help elevate spelling errors and prevent inconsistencies in displayed information.
Adding Speaker Notes
It's time to deliver the presentation. We show you the tools that help you communicate more effectively with your audience.
Level 3
Introduction
We will tell you what you will learn by watching this Video Professor lesson, and how those skills fit in with those you've learned in our earlier PowerPoint lessons.
Creating Charts
Charts allow your viewers to understand your data quickly and give your presentation credibility. In this section, we show you how to make and modify charts in PowerPoint.
Customizing Charts
Once you have created your charts, you will learn how to use many of PowerPoint's creative tools to give them more visual impact, and help clearly explain the contents of those charts.
Importing Spreadsheets
When data has been compiled in another application, there is no need to repeat the work. Simply import it into your PowerPoint presentation. We show you how it's done.
Managing the Presentation's Look
Learn how to create an effective visual environment. We show you the PowerPoint tools and how to implement them.
Using Design Templates
Using Design Templates will help you apply a consistent design and color scheme to your entire slide presentation. These templates combine background color and design with a predefined color palette.
Animating Your Slides
Applying animation schemes to your slides will help you focus your audience's attention to specific points in your presentation and give them something interesting to watch.
END
Word 2002
Level 1
Introduction
Find out what you need to do this lesson and what you are about to learn.
The Word Environment
Get a tour of the Word 2002 screen and some of the tools available to you.
Entering and Editing Text
Learn the most important skills in Word: entering and editing text.
Blocking and Manipulating Text
Maneuver your text easily using the blocking method. We show you how.
Spell Check and Thesaurus
Learn how to produce intelligent-looking documents using the Spell Checker and Thesaurus.
Inserting Graphics
Liven up your documents with images. We'll show you how to insert an image into a document.
Saving Files
Learn the proper way to save your work for safekeeping.
Printing Documents
Preview and print a hard copy version of your document.
Level 2
Introduction
We outline what is covered in the lesson and what you need to follow along.
The Normal Template
Explore the document templates Word provides and learn to use the Normal Template.
Character Formatting
Add emphasis and a new look to your text with a few mouse clicks. Learn how in this section.
Page Formats and Margins
Learn how to set up your page and set the margins for your document.
Blocking and Manipulating Text
Moving large sections of a document is easy once you know how to block and manipulate text. We show you how.
Level 3
Introduction
Find out what you need to do this lesson and what we will be doing.
Columns and WordArt
WordArt is a fun, easy way to spruce up your document. Using columns to organize your text may enhance your document's readability.
Bullets and Numbering
This feature allows you to customize the look of your layout and guide the reader's eye. We show you how to set up bullets and numbers.
Using Macros
This time saving feature is simpler than it appears. We show you how to set up and run a macro.
Setting Up Tables
Tables add order and structure to your document. In this section, learn how to set up and use tables.
Footnotes, Headers, and Footers
Inform and educate your readers with these features. As a bonus, learn about Microsoft's new feature, Smart Tags.
Mail Merge
Word makes creating mailing lists easy with Mail Merge. We walk you through the steps to get it done.
Mailing List and Merge Labels
Doing a mailing can be a daunting task. With Word, you can do it in no time. We'll help you get there.
END
Works 6.0
Level 1
Introduction
We outline the topics covered in the lessons and the new features included in this version of Works.
Touring Works Word Processing Screen
Learn how to control the word processor's windows and its screen tools.
Entering and Editing Text
We show you how to correct typing errors using keyboard and mouse commands.
Saving Files/Text Formatting
Learn the proper way to save your work for safekeeping.
Working with Clip Art
Here are the finer points of adding pictures and graphics to your word processor documents.
Working with WordArt
Converting text into a dynamic graphic object will enhance the presentation of any report or letterhead. It's also easier than you might think.
Headers/Footers, Spell Check
Discover how to make information, such as page numbers and addresses, appear on every page of your document. Also, learn how to produce error free and well-read documents.
Creating a Database
Forget about Rolodex cards and bulky folders. Learn how to catalog business or personal data, such as names, addresses, phone numbers and product information.
Performing a Mail Merge
Do you have a party or other important function coming up? Mass mailings are a breeze with Works mail merge feature.
Level 2
Introduction
What is it about Level 2 that makes it so great? Find out as we show you what you will learn in this second installment of our tutorial.
Adding Database Fields
We'll show you how to modify an established Works database field. Also, learn how to fill in missing data within a single field.
Using a Database for Statistics
Learn how to keep your data records organized to later sort or query the data to find specific information.
Database Formulas and Formatting
Learn how to combine the storage capabilities of a Works data table with the calculating power of a spreadsheet. Also learn how to format a data table to emphasize key information.
Sorting Records
Learn how to reorganize the stored data within a database, either alphabetically or numerically.
Finding Records and Using Filters
Locate records based on simple criteria within a data table. Also learn how to apply filters to a data table to find records that match a single parameter or multiple parameters.
Creating a Report
Summarize your database information so it's easy to read. We show you how to perform database operations and produce a summary report in one easy operation.
Building a Spreadsheet
Get the spreadsheet skills that allow you to track personal finances as well as perform business analysis.
Working with Formulas
Save time and increase productivity. Discover how to use some of Works' pre-made formulas as well as build your own.
Formatting a Spreadsheet
Learn how a few mouse clicks can help you emphasize key points and figures.
Level 3
Introduction
It has been quite a tour. Now sprint for the finish line in the final lesson on the home office suite.
Creating Charts
Make your numbers make sense. Turn your spreadsheet numbers into "easy to read" charts.
Chart Formatting
We show you how to alter the way Works charts your spreadsheet data. Use color and labels to convey the numbers in a visually dynamic manner.
Spreadsheet and Chart Printing
Discover the techniques that allow you to print only selected parts of a spreadsheet. In addition, we teach you the details of printing charts.
Adding Rows to a Spreadsheet
We show you where a row or column should be inserted and what happens to your spreadsheet when they are added.
Working with Templates and Wizards
Let Works do the work for you. Learn how answering a few questions can produce a 'ready-made' document, saving hours of formatting time.
Saving Files as Templates
Learn the steps that turn a regular document into a template on which other documents can base their look and formatting.
Using the Works Calendar
Bring you business and personal life into focus. Schedule meetings, appointments, even vacations and holidays! You'll never be in the doghouse for forgetting your anniversary again.
END
QuickBooks 2002
Level 1
Introduction
Discover the different ways you can use this CD to help you set up and run your business. Find out what lies ahead in this lesson and what you need to move forward.
The Set Up Interview
Setting up your business can be complex. We help you get through the process and understand what QuickBooks is asking for as you establish your company.
Manually Setting Up Your Company
Explore the QuickBooks environment while continuing to set up your company manually. Learn how to enter different kinds of accounts in this section.
Setting QuickBooks Preferences
Learn how to make QuickBooks work the way you want. Setting Preferences for yourself and your company controls how information is stored and reported. In this section we show you how.
Item Lists
There are many details to attend to in creating item lists. In this section, we cover some essential items and show you how to set them up to work for you.
Managing QuickBooks
Key to the success of any business is proper records maintenance and good management practices. We explain some helpful techniques to keep up with your business records in QuickBooks.
Level 2
Introduction
Welcome to our second lesson on QuickBooks 2002. Find out what you need to do this lesson. Gather everything you need to move forward.
Invoicing
If you want to collect money from your vendors, you'll need to know how to invoice. Discover how to use QuickBooks to get the job done fast.
Managing Customer Accounts
Things change. Learn how to keep your customer records up-to-date and accurate.
Receiving Payments
It is important to account for all of your income accurately. In this section, we show you the way.
Entering and Paying Bills
Paying bills is an inevitable part of every business. In QuickBooks there is more than one way to do that. Here you'll find out how and be able to pay bills and keep track of your expenses.
Making Adjustments to Your Register
Now and then adjustments need to be made to your register. Understand when, why, and how to make those adjustments.
Processing Payroll
This is one of the most valuable features of QuickBooks. Set up, track, and pay your employees with ease and precision after this section.
Level 3
Introduction
Find out what lies ahead and prepare to learn more valuable information about using QuickBooks 2002.
Tracking Accounts Receivable
Keeping track of who owes you what is a big part of keeping tabs on your business. Make sure you know how by utilizing this section on Accounts Receivable.
Running Reports
QuickBooks has a plethora of reports you can run to get an overview of your business. Learn about the most important reports you'll use and how to run them.
Making Journal Entries
The General Ledger is a powerful tool. Understand when and how to use it in this section.
Reconciling Bank Statements
Keeping up with your business's bank transactions is essential. With QuickBooks this tedious task can be a snap. Learn how it's done.
Tax-Related Issues
Taxes are inevitable. Learn which forms you have to file and where to get them in this section.
Year-End Procedures and Managing Files
There are several year-end procedures you'll need to run to complete the year's business. Learn what you need to know to get the job done.
END
Publisher 2002
Level 1
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
The Publisher Environment
Learn how to control the Publisher windows, galleries, and tools, including some terms you should become familiar with.
Easy Creativity
We will begin by creating and editing our own newsletter using Publisher wizards, including the newsletters, templates, and information wizard. We will also explore Color Schemes and Font Schemes.
Inserting Text
You can use articles and stories from other sources, such as Word, to insert text into your Publisher document. We will learn how to group text and connect frames to give our newsletter a professional look.
Working with Text Boxes
Once we have filled our box with text, we can color the box, add textures, gradients, and borders. Then we will make sure our newsletter is perfect by correcting our spelling and running the Design Checker.
Adding Clip Art
We show you how to locate, insert, and alter clip art to use on your pages.
Layout and Design
When we start with a template, we can add interest to our newsletter by layering clip art and balancing the elements. We also show how to use the Clip Organizer to keep your favorite artwork handy.
Finishing Touches
We will learn how to manipulate more elements of the newsletter so it is not only fun to read, but appealing to the eye as well. We will also learn how to preview and print our final product.
Level 2
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
Working with a Logo
Learn how to incorporate a logo into your publications. We will also learn how to work with the Clipboard and the Clip Organizer for easily accessible with other publications.
Creating a Business Card
While creating a business card, we will learn how to save a personal information set to use in other publications.
Adding WordArt
Turn your titles and words into art with Publisher's WordArt to add color and style to your publication.
Finishing Touches
We add the finishing touches to the business card design by using Publisher's alignment tools to balance the design and prepare your card for printing.
Creating Stationery
Learn how to make stationery and envelopes to match the design of our business cards. Also create a custom color scheme to give our stationery products consistence.
Using Mail Merge
Creating and printing your mailing list addresses on labels is easy using Publisher's mail merge features.
Creating an Invitation
You can use Publisher to create your own greeting cards and invitations using custom card stock or your own paper products.
Level 3
Introduction
We outline the topics covered in the lessons, as well as what you will need to follow along.
The Brochure - Design Basics
We will create a colorful and informative brochure exploring the different layouts and special paper options, while learning some basic design advice.
Advanced Text Editing Techniques
Learn how to edit the text in your brochure using the spacing and measurement tools, linking columns, as well as explore wrapping text around images. Then use pull quotes to draw attention to special information.
Advanced Graphic Editing Techniques
Learn how to edit the graphics in your brochures using the cropping, rotating, and arranging tools. Then see how fill effects, texturing, and patterns create interesting backgrounds.
Preparing Your Brochure for Printing
When it's time for professional printing, learn what you need to ask your printer and how to prepare your artwork for the commercial printing world.
Putting It on the Web
Learn how easy it is to change your brochure into a web page ready to publish on the Web.
END
WordPerfect 10
Level 1
Introduction
We outline the topics covered in this lesson as well as what you will need to follow along.
The WordPerfect Environment
Learn the WordPerfect interface and where to locate the most essential tools.
Entering and Editing Text
We'll show you the basics of word processing using standard keyboard and mouse commands.
Saving Files to Disc
Learn the proper way to save your work for safekeeping. We will also demonstrate different ways to open and close documents.
Selecting Text
We show you the best ways to select and modify text. Learn how to cut, copy and paste text from one area to another.
Spell Check and Thesaurus
These are some of the most indispensable tools in a word processor. We'll discuss how to correct errors and ways to modify language.
Printing
We will discuss the various options available for previewing and printing your WordPerfect documents.
Level 2
Introduction
We outline the topics discussed in this lesson and show you how to use some of the features of this lesson.
Inserting Graphics
We present the basics of how to enhance your document's appearance with pictures.
Initial Style and Formatting
The Initial Style gives us a starting point for each new document. We'll show you some advanced ways to format text to draw attention to important information.
Reveal Codes
Avoid format conflicts. Look behind the scenes to see how WordPerfect controls where a format begins and where it ends.
Page Formats and Margins
We teach you how to modify your document's page size and orientation as well as explain the new margin features of WordPerfect 10.
Line Spacing Formats
Making a document easier to read may not require a larger font size. You can alter the distance between lines of text to fit a variety of situations.
Indents and Tabs
We will show you how to use tabs and indents appropriately. Discover how different tabs are used to align text and numbers.
Working with Styles
Save valuable time by storing a set of format commands as a Style name. Once created, a style's formats can be instantly applied to any text.
Level 3
Introduction
We outline the lesson topics and briefly set up WordPerfect to perform a merge.
Merge Basics
Learn how easy it is to create hundreds of personalized letters. Discover what data files are and what they are used for. We'll show you how to create and edit your own data file using WordPerfect.
The Form File
We will show you what to change in a letter to prepare it to be merged with a data file. Learn how to use field codes to eliminate data entry.
Performing the Merge
We show you how to combine a data file with the form file to create a finished document. You will learn what to do if information is missing in the data file.
Working with TextArt and Watermarks
This is a more advanced feature of using text as a graphic element. Build on your skills by using a graphic object for the background of a document.
Performing Sorts/Creating Envelopes
We show you how to sort information alphabetically or numerically. We'll also produce an envelope to match each record in the data file.
END
QuickBooks 2003
Level 1
Introduction
You will see the set up and lesson requirements for Quickbooks 2003 and get an overview of this lesson.
The Easy Step Interview
Setting up your business can be complex. We help you get through the process and understand what QuickBooks is asking for as you establish your company.
Manually Setting Up Your Company
Explore the QuickBooks environment while continuing to set up your company manually. Learn how to enter different kinds of accounts in this section.
Setting QuickBook Preferences
Learn how to make QuickBooks work the way you want. Setting Preferences for yourself and your company controls how information is stored and reported. In this section we show you how.
Item Lists
There are many details to attend to in creating Item Lists. In this section, we cover some essential items and show you how to set them up to work for you.
Managing QuickBooks
Key to the success of any business is proper records maintenance and good management practices. We make suggestions and explain a few good ways to keep up with your business records in QuickBooks.
Level 2
Introduction
Welcome to our second lesson on QuickBooks 2002. Find out what you need to do this lesson. Gather everything you need to move forward.
Invoicing
If you want to collect money from your vendors, youÆll need to know how to invoice. Discover how to use QuickBooks to get the job done fast.
Managing Customer Accounts
Things change. Learn how to keep your customer records up-to-date and accurate.
Receiving Payments
It is important to account for all of your income accurately. In this section, we show you the way.
Entering and Paying Bills
Paying bills is an inevitable part of every business. In QuickBooks there is more than one way to do that. Here youÆll find out how and be able to pay bills and keep track of your expenses.
Making Adjustments
Now and then adjustments need to be made to your register. Understand when, why and how to make those adjustments.
Processing Payroll
This is one of the most valuable features of QuickBooks. Set-up, track and pay your employees with ease and precision after this section.
Level 3
Introduction
Find out what lies ahead and prepare to learn more valuable information about using QuickBooks 2002.
Tracking Accounts Receivable
Keeping track of who owes you what is a big part of keeping tabs on your business. Make sure you know how by utilizing this section on Accounts Receivable.
Running Reports
QuickBooks has a plethora of reports you can run to get an overview of your business. Learn about the most important reports youÆll use and how to run them.
Making Journal Entries
The General Ledger is a powerful tool. Understand when and how to use it in this section.
Reconciling Bank Statements
Keeping up with your businessÆs bank transactions is essential. With QuickBooks this tedious task can be a snap. Learn how itÆs done.
Tax Related Issues
Taxes are inevitable. Learn which forms you have to file and where to get them in this section.
Year-End Procedures and Managing Files
At the end of the year, there are several procedures youÆll need to run to complete the yearÆs business. In this section, learn what you need to know to get the job done.
END
HTML
Level 1
Introduction
How was the Internet developed, and just what is this HTML stuff anyway?
How the Internet Works
How do all those computers that are hooked together find each other? Learn about the protocols and procedures for computers to talk to each other and find information.
Coding Your First Page
Start with the basic building blocks of an HTML page. Pick up the fundamentals of HTML tags and how to use them.
Formatting Text with HTML
So many formats, so little time! Discover the basic tags used to make content appear the way it was meant to be.
Advanced Text Formatting
OK, it takes a little more time for formatting text. From italics to lists, you can gain better control over the text on your HTML pages.
Hyperlinking Basics
Anchors away! Create the means to jump from one area of a document to another and between separate documents using the anchor tag.
More Hyperlinking
Get creative with links. Learn how to link to external documents on the Web and how to add color and pizzazz to the boring standard hyperlink.
HTML Table Basics
Get organized. Layout of text and data is much easier to control when you know the basics of building tables.
Level 2
Introduction
YouÆve got the basics down. Now add spice to your Web pages by adding color and graphics. Also, learn advanced methods for page layout and linking to other documents.
Color on the Web
Plain black-and-white Web pages are boring. Just naming the color to use is limiting. We will show you how to put the power of the hexadecimal system to work in selecting colors for your pages.
Understanding Web Graphics
A picture is worth a thousand words. The World Wide Web is particular about what types of graphics work best for a particular situation. Here is an overview of the different options available.
All About Image Attributes
Control the size of your images efficiently. What if the person who is viewing your site canÆt see the pictures? Adding just a few extra pieces of code can make all the difference in the world.
Optimizing Images for the Web
You know some of the ways to put pictures and graphics into a Web page. We will show you a few things to keep in mind as you make those images ready for Web delivery.
Formatting a Page with Tables
They arenÆt just for eating on anymore. HTML tables allow data and other information to be presented in a clear and concise format.
Advanced Table Layout
Take the use of HTML tables to the next level by laying out an entire Web page using tables inside of tables. Now weÆre cookinÆ!
Linking with Image Maps
Use one image to do the work of many. Define multiple hotspots within an image to link to different documents from a single graphic.
Level 3
Introduction
LetÆs get advanced in this final lesson on HTML. In addition to more handy code to utilize in your Web site, weÆll also lead you through possible steps to post your site on the Web and register it with search engines.
HTML Forms
Have you always wanted to know who was coming to your site? Find out with these easy-to-use tags allowing your visitor to give you some information.
Advanced Form Elements
Do a quick survey and limit the possible responses with more advanced form elements such as radio buttons, checkboxes and size limits.
Activating the Form
Now that the user has filled out the form, where does it go? Tell the form where to file the data and give the user a response by using a CGI script on the server.
Frames
Frames are another way to control the appearance of your pages. Frames help define the layout of the content of a Web site.
Cascading Style Sheets
Your pages already have style. You just need a way to give them a uniform appearance. Cascading Style Sheets (CSS) enable you to quickly format all of your pages at once.
Embedded and Inline Styles
Get even more style. Once you have developed the overall look of your site using an external sheet, refine the appearance of the individual pages with these two methods.
Publishing Your Site
Now that everything is finished, we will show you how to upload those files to the Web and make sure the search engines have everything they need to drive visitors to your site.
END
Microsoft Money 2003
Level 1
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
The Money Layout
Learn how to use the various menus and icons to navigate through Money and customize your Money Home Page.
Setting Up Your Accounts
WeÆll start using Money by creating a Money File, setting up a checking account, and setting priorities. Then weÆll set up bills, paychecks, and a savings account.
Working with the Check Register
Use the check register screen to record bills and deposits, electronic payments, project your cash flow, create payees, and analyze your spending habits.
Entering Split Transactions
Learn how to break down transactions that have items in multiple categories so your reports are more accurate and useful.
Printing Checks and Other Register Tools
Use Money to print your checks on blank check stock one at a time or in a batch. Cut, paste, and flag transactions for follow-up.
Reconciling Your Bank Statement
Balance your checking account and correct any data entry errors with the help of MoneyÆs tools.
Managing Money Files
Create or disable passwords, back up your data files, archive transactions, and restore your data after a crash.
Level 2
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
Adding New Accounts
Learn how to add accounts to track cash purchases, loans, investments, personal property, real estate, and credit cards.
Adding Loan Accounts
Add accounts to track the value of an asset against the amount owed. This can be useful for tracking equity in assets like a home or vehicle.
Managing Bills and Deposits
Stay on top of your bills and deposits with Money û avoid making late payments and plan out your cash flow so you can keep your credit in good shape.
Managing Categories and Payees
Categorize your expenses to track your income and spending. Adapt and customize the categories in Money to suit your situation.
Generating Money Reports
Create reports and charts to show you how you are spending your money, what you have, what you owe, and more.
Money and the Internet
Link your bank account to your Money file, set up electronic payments, and set up a Microsoft Passport to secure your data.
Online Banking and Money Side
Submit electronic payments, download transactions from a linked account, and use MoneySide -- MoneyÆs interface with Internet Explorer.
Level 3
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
Adding an Investment Account
Create a portfolio for keeping track of your investments. Track regular investment accounts as well as IRAs.
Managing Your Portfolio
Keep an eye on stocks you own as well as those you are thinking about investing in. Research stocks with the Stock Screener, company reports, and other Money tools.
Using the Money Advisor
Set account balance alerts, track your monthly discretionary spending on the Home Page, and use Advisor FYI.
Using the Budget Planner
Learn how to fine tune your budget, save towards your goals, and set alerts for when you are close to exceeding a budget category.
Using the Lifetime Planner
Create a projection of your lifetime finances based on the information you have now. Then make changes to your plan to reach your retirement and other financial goals.
Tax Tools
Keep your finances organized to make tax time easier, whether you prepare your taxes by hand, file electronically, or export your data to a tax preparation software package.
Getting the Most out of Money
Synchronize your data with MSN Money Central so you can access your financial information from any computer with an Internet connection. Sign up for e-mail about the stock market and sign up for MSN bill pay services.
END
Quicken 2003
Level 1
Introduction
Welcome to Quicken 2003! In this section we discuss the topics that will be covered in Level 1.
Creating a Data File
Set up a new practice checking account to learn about the features of a data file.
Quicken Layout
Explore the Quicken screen and layout. Also learn the difference between using the Tab key and the Enter key within Quicken.
Learn the Check Register
Learn about the many features of the check register in Quicken such as balance alerts, automatic balance calculation and how to enter a debit card transaction.
Editing the Category List
Use the Expense and Income categories to classify a transaction and create custom transaction sub-categories that make sense to you.
Recording Split Transactions
Discover the split transaction window and how you can apply several expense categories to a single entry. This allows for detailed reporting of your expenses.
Creating and Printing Checks
Create and print checks, pay bills electronically and set reminders for when bills are coming due.
Reconcile Your Bank Statement
Become skilled at balancing your checkbook with the automated features of Quicken.
Level 2
Introduction
In this section we recap the topics discussed in Level 1, and outline learning objectives for Level 2.
Setting Up a Credit Card Account
Set up a credit card account. Keep track of how money paid out of your checking account pays down your credit card debt.
Setting Up a Loan
Use Quicken to determine how much of a loan you can afford. Create a corresponding asset to match your loanÆs liability to calculate equity gained over time.
Setting Up a Loan Payment
Schedule payments, calculate principal and interest paid, manage payees, and forecast your equity balance.
Setting Up Your Account
Link your accounts in Quicken with your online bank accounts and take advantage of QuickenÆs integration with the Internet. Download transactions to your account register and get set up to pay bills online.
Making Online Payments
Pay your bills online through QuickenÆs interface as well as set up other recurring payments and deposits.
Online Banking
Connect to your bank, authorize recurring and bill payments, and verify transactions.
Level 3
Introduction
In this section we discuss the topics that will be covered in Level 3.
Working with an Investment Account
Set up a new practice investment account and track its performance. Explore additional investments to add to your portfolio.
Using the Investing Center
Learn the various ways to view investments and go online to find up-to-date market information.
Analysis and Reports
Explore the many different alerts offered by Quicken and see a visual summary of account values.
Exploring the Planning Center
Use planners that will help you set savings goals for major life decisions such as buying a home, education expenses, and debt reduction.
Using the Tax Center
Discover how Quicken can help you figure out your entire tax picture, so that you always know where you stand.
Reports and Graphs
Create reports and graphs to help stay on top of your financial situation. These visual aides provide a valuable resource for analyzing your finances.
END
Word 2003
Level 1
Introduction to Word
Learn about the exciting topics covered in this lesson.
The Word Environment
Take a tour of the Word 2003 screen and some of the features you will be using.
Entering and Editing Text
Learn the basics of entering and editing text.
Saving Documents
Saving is the most important skill when working with software programs.
Formatting Text
Change text to fit your needs and style. We show you how!
Spell Check and Thesaurus
Learn how to ensure your document is spelled correctly and find alternative words.
Printing Documents
Preview your document and print to paper.
Level 2
Introduction
We discuss the topics covered in this lesson.
Templates and Task Panes
Explore the predefined templates Word has created. Learn about the many features of the task pane.
Styles and Text Formatting
Learn how to add a new look to your documents with just a few clicks of the mouse.
Page Formats and Margins
Find out how to set up and change the fundamental settings of your document.
Alignment and Spacing of Text
Change the way text appears on your document with the alignment and line spacing tools.
Graphics, WordArt, and Symbols
Jazz up your document using graphic files and WordArt!
Tabs
In this section, we show you how to apply and change tab settings.
Level 3
Introduction
Learn about the topics covered in this lesson.
Using Bullets and Numbering
This feature allows you to create bulleted and numbered lists to set apart important information.
Columns, Boxes, and Tables
Columns and tables are a great way to display information in your document.
Macros
Macros are a time-saving, easy feature. We show you how to create and use macros.
Headers, Footers, and Smart Tags
Learn how to insert and change headers and footnotes. Also, we will teach you about Microsoft WordÆs Smart Tag feature.
Find and Replace
This is hands down the fastest way to find key words in a document and replace them as needed.
Mail Merge, Lists, and Labels
Need to create a lot of mailing lists and labels? ItÆs no problem in Word.
Advanced Word
We discuss some of the more advanced functions of Word.
END
Excel 2003
Level 1
Introduction
We outline the topics covered in this lesson, as well as what you will need to follow along.
The Excel Environment
Become familiar with the Excel screen environment and toolbars.
Creating a New Spreadsheet
Begin building a spreadsheet, learn formatting techniques, and use the spell checker.
Saving Files
Learn how to save your files using AutoSave and other techniques.
Formatting
Emphasize key points and figures with just a few mouse clicks.
Working with Formulas
Build your own formulas and use ExcelÆs pre-defined formulas or functions.
Entering Data
Enter data and explore "what-if" scenarios using your new worksheet.
Manipulating Worksheets
Name, add, copy, color, and navigate multiple worksheets.
Printing
Explore different printing options. Preview and print the finished product.
Level 2
Introduction
A brief look at the topics covered in this lesson.
Multiple Open Windows
Open and organize multiple workbooks on one screen.
Creating Charts
Explore different chart types, begin building a chart, and learn basic Excel chart features.
Manipulating Chart Elements
Work with specific chart elements and apply advanced charting features.
Conditional Formatting
Learn about conditional formatting and set up different "what if" scenarios comparing projected sales results.
Relative and Absolute
Build formulas and explore the differences between absolute and relative cell addresses.
Clipboard and Workspaces
Create and save a workspace, and use the Microsoft clipboard.
The Bottom Line
Summarize data in a table, create a chart to display findings, and see how different æwhat ifÆ scenarios affect the bottom line.
Hiding Data and Cell Ranges
Apply headers and footers, hide and show columns and rows, and print cell ranges.
Level 3
Introduction
A brief look at the topics covered in this lesson.
Database Basics
Explore fields, records, and data validation.
Watch Cells and Parsing
Name a cell range, create a watch cell, and use parsing.
Forms and Sorting
Work with ExcelÆs data form feature and learn how to sort records.
Advanced Formulas
Apply conditional formulas to build æWhat IfÆ analysis skills.
Finding Records
Search the database for specific records.
Modifying Data Tables
Organize a spreadsheet to enter more information into a data table.
Queries
Work with custom and auto data filters to run database queries.
END
PowerPoint 2003
Level 1
Introduction
Learn about the topics covered in this lesson, as well as what youÆll need to follow along.
The PowerPoint Environment
Explore PowerPointÆs icons, toolbars, and menus. Discover how PowerPoint commands can dramatically enhance your presentation.
Creating a Presentation
Use PowerPointÆs design templates to begin developing a professional presentation. Learn which backgrounds work best for different types of presentations.
Entering Text
PowerPoint offers many dynamic tools that create custom slides with ease. Learn how to enter and modify text with the help of text placeholders.
Formatting and Enhancing Text
Apply diverse formats to make your text come alive. Then look at a unique tool that copies complex formatting across multiple blocks of text.
Using the Outline Pane
Organize and enter text and slides with the help of the Outline Pane. Use the pane to plan a dynamic presentation that will convey your message clearly and effectively.
Viewing Your Presentation
Explore valuable PowerPoint tools that allow you to display a presentation after completion.
Level 2
Introduction
Learn about the topics covered in this lesson, as well as what youÆll need to follow along.
Using Text Boxes
Highlight important points in your presentation and bring text to life with these unique tools.
Adding AutoShapes
Use PowerPointÆs AutoShapes feature to turn simple shapes into eye-catching graphics.
Slide Sorter View
Master your presentation by looking at the bigger picture. The Slide Sorter offers an effective way to organize and manage extensive presentations.
Clip Art and WordArt
Learn how to utilize graphics and images to add visual impact and clarity to your presentation.
Checking for Errors
PowerPointÆs error checking tools help alleviate spelling errors and prevent inconsistencies.
Notes and Audience Handouts
When itÆs time to deliver your presentation, learn invaluable tools that will guarantee effective communication with your audience.
Level 3
Introduction
Learn about the topics covered in this lesson, as well as what youÆll need to follow along.
Creating Charts
PowerPoint charts allow viewers to comprehend data quickly while adding credibility to any presentation.
Customizing Charts
Explore PowerPointÆs many creative tools that give charts more clarity and visual impact.
Importing Spreadsheets
Eliminate extra work and reduce overall project time by importing data from other applications.
The PresentationÆs Appearance
Create a dramatic visual environment with the help of PowerPoint tools.
Using Animations
Focus your audienceÆs attention on specific points by applying animation schemes to your slides.
The Slide Master
Build continuity between slides by adding, deleting, and modifying elements that appear throughout a presentation.
END
Access 2003
Level 1
Introduction
We outline the topics covered in this lesson, as well as what you will need to follow along.
The Access Environment
Get a tour of the Access environment and set up your screen.
Creating a Database
Learn what a database is and how it can help you organize information.
Creating and Using Tables
Tables are the storage unit for all of your database information. We show you how to create database fields in a table and how to modify their properties.
Entering Data into a Table
We simplify the process of entering and copying data into a table. YouÆll also learn how to create a Lookup field that makes entering data easier and more precise.
Creating and Using Forms
Forms can make data entry even easier. Learn how to create and manipulate a form to fit your needs.
Adding a Field to a Form
We show you how to add a new field to an existing table, which can then be added to an existing form.
Level 2
Introduction
We outline the topics covered in this lesson, as well as what you will need to follow along.
Table Wizard
Discover just how easy Access is to use with the guidance of the Table Wizard.
Form Wizard
Turn the tedious task of producing a form into a creative step-by-step process.
Datasheet View
Learn how to build a table from the Datasheet view.
Table Relationship
Explore one of the most powerful aspects of database development: building relationships between tables.
Creating Queries
Queries are the real power of databases. Learn how to extract the right information by asking the right questions.
Using Queries in Forms
Combine multiple database objects to enhance a formÆs ability to retrieve information quickly.
Creating Reports
Find out what a report is and how to build one. Then use a wizard to create a report that works for you.
Multiple Table Queries
Learn how to gather information from more than one table to get your results.
Creating a Custom Report
Create a custom report from scratch, and find out how to modify any report created in Access.
Level 3
Introduction
Find out whatÆs included in this lesson: Locate and open the files youÆll need.
Importing Data
Discover which programs Access works with, and learn how to import data from them.
Find Duplicates Query
Use the Duplicate Wizard to eliminate duplicate records. Learn what a dynaset is and how to define relationships to build queries.
Select vs. Action Queries
Explore the difference between various types of action queries, and set advanced query criteria.
Linking Tables
Find out what makes linking tables such a useful process, and learn how to do it.
Using a Union Query
Pull your data together using a union query. Explore the SQL programming behind the query scenes.
END
FrontPage 2003
Level 1
Introduction
Learn about the topics and projects covered in this lesson, as well as what youÆll need to know in order to follow along.
Web Site Basics
Become familiar with the basic components and design elements of a web site. Develop a look and feel for your own site.
The FrontPage Environment
Tour the FrontPage environment while learning to utilize powerful web site tools.
FrontPage Views
Discover the power of FrontPageÆs organization toolbar. Learn to maximize this power while developing an overall web site design.
Working with Templates
Begin building a site with the help of a wide range of FrontPage templates. Use these templates to construct your siteÆs foundation.
Saving in FrontPage
Explore several methods of saving web pages and their significance to a siteÆs functionality.
Level 2
Introduction
Learn about the multiple elements necessary to develop and navigate the content of your web site.
FrontPage Themes
Explore the numerous FrontPage options available to create a unique look and feel for a site.
Working with Tables
Tables are an excellent layout tool for web pages. Learn how formatting tables can directly contribute to the content of a web site.
Working with Images
Images are imperative to an attractive web site. Determine how image placement and functionality can do more than just enhance the appearance of a site.
Working with Thumbnails
Using thumbnails on a web site is an effective tool in web site design. Understand how thumbnails can keep a site looking clean and uncluttered.
Bookmarks and Hyperlinks
Hyperlinks are an integral part of any web site. Learn how to effectively use bookmarks and hyperlinks to enhance the architecture of a site.
Level 3
Introduction
Discover valuable tools necessary to construct a successful web site. Then learn how to publish a finished site to the Internet.
Borders and Graphic Effects
Understand the significance of shared borders and find out how graphic effects can dramatically enhance any web site.
Working with Frames
Frames play an important role in the functionality of a web site. Build a frames page and then witness how the page can have multiple uses.
Custom Forms
Forms are used extensively on web sites. Create and apply a custom form to your site.
Form Functionality
Creating forms is just one aspect of effectively using forms on a site. Manipulate several data rules and options to get the most out of your forms.
The Form Page Wizard
Develop useful forms with the help of FrontPageÆs invaluable Form Page Wizard.
Testing a Web Site
Testing is an integral part in validating the functionality of any site. Learn important methods to verify that your site is ready to be published.
Publishing a Web Site
Look at several procedures and checklists necessary to guarantee the success of your site. Then preview the site before actually publishing it to the Web.
END
Outlook 2003
Level 1
Introduction
We outline the topics covered in this lesson, as well as what you will need to follow along.
General Layout
Take a tour of the different areas of Outlook and discover the new Reading pane.
Basics of E-mail
Learn the fundamental principles of the most popular form of communication on the Internet - E-mail.
Arranging E-mails
Arrange and organize your inbox, and explore OutlookÆs e-mail sorting features.
Replying to E-mails
Learn how to reply, forward, and send attachments with your e-mail.
E-mail Formats
Explore different formats for sending and receiving e-mail. Incorporate stationary and signatures into your e-mail.
Incoming E-mail Feature
Customize the new Desktop Alert feature for incoming e-mail.
Junk E-mail Feature
Filter out unwanted junk e-mail from your inbox.
Level 2
Introduction
We outline the topics covered in this lesson, as well as what you will need to follow along.
Navigation Pane
We explore the new Navigation Pane, which provides easy access to all the features in Outlook.
Contacts
Find out how to use Contacts to store e-mail addresses, phone numbers, mailing addresses, pictures, and other information.
Calendar
We customize the calendar and scheduling component of Outlook.
Scheduling Appointments
Set up some appointments, meetings, and events with the Outlook Calendar.
Recurrence
Learn how to create recurring appointments, meetings, and events for our calendar.
Tasks
Create a personal or business "to-do" list using the Task feature of Outlook.
Journal and Notes
Record your actions and view them later on a timeline using the Journal. Replace your sticky notes with digital Outlook Notes.
Level 3
Introduction
We outline the topics covered in this lesson, as well as what you will need to follow along.
Advanced E-mail Features
Discover advanced e-mail features, including how to send web links and vCards.
Search Data in Outlook
Learn to search all contacts, tasks, e-mail, or any other data in Outlook using the Search toolbar and Search folders.
Organizing E-mails
Increase efficiency with these tips for organizing and identifying e-mails.
Setting Up E-mail Rules
Set up rules for automatically processing and organizing your e-mail messages.
Customizing Outlook
Personalize Outlook by creating new e-mail accounts, modifying toolbars, and changing views.
Archiving E-mail
Learn how to safely store e-mail for future reference.
Advanced Outlook Options
Explore advanced features such as send/receive, spell check, AutoCorrect, and Smart Tags.
END
Publisher 2003
Level 1
Introduction
Learn about the topics and projects covered in this lesson, as well as what youÆll need to follow along.
The Publisher Environment
Become familiar with Publisher terms and work with windows, galleries, and tools.
Starting a Project
Create and edit a newsletter using Publisher wizards and templates.
Inserting Text
Insert articles and stories from other sources into our Publisher document. Group text and connect frames for a professional look.
Text Boxes
Enhance text boxes with color, textures, gradients, and borders. Create flawless publications with help from the Design Checker.
Inserting Images
Accentuate documents by inserting and manipulating Clip Art and other images.
Layout and Design
Layer images and balance elements within a publication. Discover the convenience and efficiency of the Clip Organizer.
Special Effects
Explore the power of Publisher to polish finished documents. Preview and print our final product.
Level 2
Introduction
Learn about the topics and projects covered in this lesson, as well as what youÆll need to follow along.
Working with Logos
Incorporate a logo into your publication. Use the Clipboard and the Clip Organizer to maximize accessibility among multiple publications.
Creating a Business Card
Use personal information sets to produce a business card.
Adding WordArt
Turn your titles and words into art with PublisherÆs WordArt feature.
Finishing Touches
Add the final touches to our business card by using PublisherÆs alignment tools to balance the design and prepare the card for printing.
Creating Stationery
Make stationery and envelopes to match the design of our business card. Create specialized color schemes to add consistency to multiple stationery products.
Using Mail Merge
Creating and printing multiple addresses on labels is made easy with the help of PublisherÆs Mail Merge feature.
Creating an Invitation
Generate professional invitations and greeting cards using custom card stock or your own paper products.
Level 3
Introduction
Learn about the topics and projects covered in this lesson, as well as what youÆll need to follow along.
Brochure Design Basics
Use design tips to produce colorful and informative brochures. Explore multiple layout designs and special paper options to create professional publications.
Advanced Text Editing
Edit text in a brochure using PublisherÆs spacing and measurement tools. Wrap text and link columns around images, and explore the value of pull quotes.
Advanced Graphic Editing
Master brochure graphics with the help of PublisherÆs cropping, rotating, and arranging tools. Create attractive backgrounds with fill effects, texturing, and patterns.
Outside Printing
Learn how to prepare a document for sending to a commercial printer.
Publications on the Web
Use the power of Publisher to easily transform publications into web pages.
END
Photoshop 7.0
Level 1
Introduction
A brief look at the topics covered in this lesson.
The Photoshop Window
Become familiar with basic Photoshop features and learn where they are located around the window.
Opening Image Files
Understand resolution and how it affects image quality. Locate and open files, and save them in different formats.
The File Browser
Use the browser to sort, orient, and manage multiple images.
Creating New Files
Learn how to customize file appearance by specifying size and resolution.
The Work Area
Increase workspace efficiency by utilizing the view, move, and zoom functions.
Using the Toolbox
Use this fundamental feature to access many of the most frequently used commands.
Working with Palettes
Explore the different palettes and use them to verify settings and manipulate images.
The Layers Palette
Separate image data in a file so it can be easily moved and modified.
Managing Multiple Layers
Work with layers to build a fun, fictitious landscape scene.
Level 2
Introduction
A brief look at the topics covered in this lesson.
Making Selections
Learn how to isolate and alter certain areas of an image.
Transforming Images
Become familiar with changing the size of images and putting them together
Advanced Compositing
Explore the different methods for building layered images.
Quick Mask Mode
Look at a different method of creating a selection.
Retouching Images
Learn how to restore old photographs by removing defects and improving contrast.
Color Balance
Understand how to adjust and control color.
Working with Text
Make images more interesting with text.
Vector Shapes
Build scalable shapes with vectors and add effects to them.
Level 3
Introduction
A brief look at the topics covered in this lesson.
Setting Preferences
Become familiar with the many ways Photoshop can be set up.
Color Management
Learn how image profiles and modes affect image appearance.
Selecting Colors
Explore the Color Picker and understand bit depth.
The Actions Palette
Make a series of adjustments to an image that can be applied later to others.
Automating Functions
See how many repetitive tasks can be set up to perform with a single click.
Using Filters
Explore the different effects available using filters.
Rollovers and Image Maps
Learn about dividing a webpage into sections so that it can be downloaded faster by a web browser.
Animation in ImageReady
Use ImageReady to create an animated graphic for the web.
Optimizing Web Graphics
Trim down the file size of a web page to make it easier to view on the web.
END
Microsoft Money 2004
Level 1
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
The Money Layout
Learn how to use the various menus and icons to navigate through Money and customize your Money Home Page.
Setting Up Accounts
WeÆll start using Money by creating a Money File, setting up a checking account, and setting priorities. Then weÆll set up bills, paychecks, and a savings account.
The Check Register
Use the check register screen to record bills and deposits, electronic payments, project your cash flow, create payees, and analyze your spending habits.
Split Transactions
Learn how to break down transactions that have items in multiple categories so your reports are more accurate and useful.
Printing Checks
Use Money to print your checks on blank check stock one at a time or in a batch. Cut, paste, and flag transactions for follow-up.
Account Balancing
Reconcile your checking account and correct any data entry errors with the help of MoneyÆs tools.
Managing Money Files
Create or disable passwords, back up your data files, archive transactions, and restore your data after a crash.
Level 2
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
Adding New Accounts
Learn how to add accounts to track cash purchases, loans, investments, personal property, real estate, and credit cards.
Adding Loan Accounts
Add accounts to track the value of an asset against the amount owed. This can be useful for tracking equity in assets like a home or vehicle.
Bills and Deposits
Stay on top of your bills and deposits with Money û avoid making late payments and plan out your cash flow so you can keep your credit in good shape.
Categories and Payees
Manage your expenses to track your income and spending. Adapt and customize the categories in Money to suit your situation.
Generating Reports
Create reports and charts to show you how you are spending your money, what you have, what you owe, and more.
Money and the Internet
Link your bank account to your Money file, set up electronic payments, and set up a Microsoft Passport to secure your data.
Online Banking
Submit electronic payments, download transactions from a linked account, and use MoneySide -- MoneyÆs interface with Internet Explorer.
Level 3
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
Investment Accounts
Create a portfolio for keeping track of your investments. Track regular investment accounts as well as IRAs.
Your Portfolio
Keep an eye on stocks you own as well as those you are thinking about investing in. Research stocks with the Stock Screener, company reports, and other Money tools.
The Money Advisor
Set account balance alerts, track your monthly discretionary spending on the Home Page, and use Advisor FYI.
The Budget Planner
Learn how to fine tune your budget, save towards your goals, and set alerts for when you are close to exceeding a budget category.
The Lifetime Planner
Create a projection of your lifetime finances based on the information you have now. Then make changes to your plan to reach your retirement and other financial goals.
Tax Tools
Keep your finances organized to make tax time easier, whether you prepare your taxes by hand, file electronically, or export your data to a tax preparation software package.
Maximizing Money
Synchronize your data with MSN Money Central so you can access your financial information from any computer with an Internet connection.
END
Quicken 2004
Level 1
Introduction
Welcome to Quicken 2003! In this section we discuss the topics that will be covered in Level 1.
Creating a Data File
Set up a new practice checking account to learn about the features of a data file.
Quicken Layout
Explore the Quicken screen and layout. Also learn the difference between using the Tab key and the Enter key within Quicken.
Learn the Check Register
Learn about the many features of the check register in Quicken such as balance alerts, automatic balance calculation and how to enter a debit card transaction.
Editing the Category List
Use the Expense and Income categories to classify a transaction and create custom transaction sub-categories that make sense to you.
Recording Split Transactions
Discover the split transaction window and how you can apply several expense categories to a single entry. This allows for detailed reporting of your expenses.
Creating and Printing Checks
Create and print checks, pay bills electronically and set reminders for when bills are coming due.
Reconcile Your Bank Statement
Become skilled at balancing your checkbook with the automated features of Quicken.
Level 2
Introduction
In this section, we review the topics discussed in Level 1 and outline the learning objectives for Level 2.
Creating a Credit Card Account
Set up a credit card account. Keep track of how money paid out of your checking account pays down your credit card debt.
Setting Up a Loan
Use Quicken to determine how much of a loan you can afford. Create a corresponding asset to match your loanÆs liability and calculate equity gained over time.
Setting Up a Loan Payment
Schedule payments, calculate principal and interest paid, and manage payees.
Setting Up Online Checking
Link your accounts in Quicken with your online bank accounts and take advantage of QuickenÆs integration with the Internet.
Setting Up Online Payees
Download transactions to your account register and get set up to pay bills online.
Making Online Payments
Pay your bills online through QuickenÆs interface, as well as set up other recurring payments and deposits.
Online Banking
Connect to your bank, authorize recurring bill payments, and verify transactions.
Level 3
Introduction
In this section, we discuss the topics that will be covered in Level 3.
Investment Accounts
Set up a new practice investment account and track its performance. Explore additional investments to add to your portfolio.
Adding a Mutual Fund
Learn how to set up and monitor mutual fund accounts.
Using the Investing Center
Learn the various ways to view investments and go online to find up-to-date market information.
Analysis and Reports
Explore the many different alerts offered by Quicken and see a visual summary of account values.
Exploring the Planning Center
Use planners that will help you set savings goals for major life decisions, such as buying a home, education expenses, and debt reduction.
Using the Tax Center
Discover how Quicken can help you figure out your entire tax picture, so you always know where you stand.
Reports and Graphs
Create reports and graphs to help stay on top of your financial situation. These visual aides provide a valuable resource for analyzing your finances.
END
QuickBooks 2004
Level 1
Introduction
You will see the setup and lesson requirements for QuickBooks and get an overview of this lesson.
The EasyStep Interview
Setting up your business can be complex. We help you get through the process and understand what QuickBooks is asking for as you establish your company.
Setting Up Your Company
Explore the QuickBooks environment while continuing to set up your company manually. Learn how to enter different kinds of accounts in this section.
Setting QuickBooks Preferences
Learn how to make QuickBooks work the way you want. Setting preferences for yourself and your company controls how information is stored and reported. In this section we show you how.
Item Lists
There are many details to attend to in creating item lists. In this section, we cover some essential items and show you how to set them up to work for you.
Managing QuickBooks
The key to the success of any business is proper records maintenance and good management practices. We make suggestions and explain a few good ways to keep up with your business records in QuickBooks.
Level 2
Introduction
Welcome to our second lesson on QuickBooks. Find out what you need to complete this lesson. Gather everything you need to move forward.
Invoicing
If you want to collect money from your vendors, youÆll need to know how to invoice. Discover how to use QuickBooks to get the job done fast.
Managing Customer Accounts
Things change. Learn how to keep your customer records up-to-date and accurate.
Receiving Payments
It is important to account for all of your income accurately. In this section, we show you the way.
Entering and Paying Bills
Paying bills is an inevitable part of every business. In QuickBooks there is more than one way to do that. Here youÆll find out how and be able to pay bills and keep track of your expenses.
Making Adjustments
Now and then adjustments need to be made to your register. Understand when, why, and how to make those adjustments.
Processing Payroll
This is one of the most valuable features of QuickBooks. Set up, track, and pay your employees with ease and precision after this section.
Level 3
Introduction
Find out what lies ahead and prepare to learn more valuable information about using QuickBooks.
Tracking Accounts Receivable
Keeping track of who owes you money is a big part of keeping tabs on your business. Make sure you know how by utilizing this section on Accounts Receivable.
Running Reports
QuickBooks has a variety of reports you can run to get an overview of your business. Learn about the most important reports youÆll use and how to run them.
Making Journal Entries
The General Ledger is a powerful tool. Understand when and how to use it in this section.
Reconciling Bank Statements
Keeping up with your businessÆs bank transactions is essential. With QuickBooks this tedious task can be a snap. Learn how itÆs done.
Tax-Related Issues
Taxes are inevitable. Learn which forms you have to file and where to get them in this section.
Year-End Procedures
At the end of the year, there are several procedures youÆll need to run to complete the yearÆs business. In this section, learn what you need to know to get the job done.
END
Quicken 2005
Level 1
Introduction
Welcome to Quicken 2005! In this section we discuss the topics that will be covered in Lesson One.
Creating a Data File
Set up a practice checking account to learn about the features of a data file.
Quicken Layout
Explore the Quicken screen and its layout. Also learn the difference between using the Tab key and the Enter key within Quicken.
Working with the Check Register
Learn about the many features of the check register in Quicken such as balance alerts, automatic balance calculation, and how to enter a debit card transaction.
Editing the Category List
Use the Expense and Income categories to classify a transaction and create custom transaction sub-categories that fit your needs.
Recording Split Transactions
Discover the Split Transaction window and learn how to apply several Expense categories to a single entry, allowing for detailed reporting of your expenses.
Creating and Printing Checks
Create and print checks, pay bills electronically, and set reminders for when bills are coming due.
Reconcile Your Bank Statement
Become skilled at balancing your checkbook with the automated features of Quicken.
Level 2
Introduction
In this section we recap the topics discussed in Lesson One and outline learning objectives for Lesson Two.
Setting Up a Credit Card Account
Set up a credit card account. Keep track of how money paid out of your checking account pays down your credit card debt.
Setting Up a Loan
Use Quicken to determine how large a loan you can afford. Create a corresponding asset to match your loanÆs liability and calculate equity gained over time.
Setting Up a Loan Payment
Schedule payments, calculate principal and interest paid, manage payees, and forecast your equity balance.
Setting Up Online Checking
Link your accounts in Quicken with your online bank accounts and take advantage of QuickenÆs integration with the Internet. Download transactions to your account register and get set up to pay bills online.
Setting Up Online Payees
Define who gets paid, from what account, by what means, and when. Find out lead times for various types of online payments.
Making Online Payments
Pay your bills and set up other recurring payments and deposits through QuickenÆs online interface.
Online Banking
Connect to your bank, authorize recurring and one-time bill payments, and verify transactions.
Level 3
Introduction
In this section we discuss the topics that will be covered in Lesson Three.
Working with an Investment Account
Set up a practice investment account and track its performance. Explore additional investments to add to your portfolio.
Adding a Mutual Fund
Learn to transfer funds from a pre-existing account and how to record income events including dividend reinvestment plans.
Using the Investing Center
Learn the various ways to view investments and go online to find up-to-date market information.
More Investing Center Tools -- Analysis and Reports
Explore the many different alerts offered by Quicken and see a visual summary of account values.
Exploring the Planning Center
Use planners that will help you set savings goals for major life decisions such as buying a home, education expenses, and debt reduction.
Using the Tax Center
Discover how Quicken can help you figure out your entire tax picture, so that you always know where you stand.
Reports and Graphs
Create reports and graphs to help stay on top of your financial situation. These visual aides provide a valuable resource for analyzing your finances.
END
Microsoft Money 2005
Level 1
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
The Money Layout
Learn how to use the various menus and icons to navigate through Money and customize your Money Home Page.
Setting Up Your Accounts
WeÆll start using Money by creating a Money Data File, setting up a checking account, and setting balance alerts.
Setting Up Bills and Deposits
Learn the difference between Essential and Advanced features and how to set up and categorize recurring and one-time payments and deposits.
Working With the Check Register
Enter payments into the register for manual checks or have Money print electronic checks.
Entering Split Transactions
Learn how to break down transactions that have items in multiple categories so your reports are more accurate and useful.
Printing Checks and Other Register Tools
Use Money to print your checks on blank check stock one at a time or in a batch. Cut, paste, and flag transactions for follow-up.
Reconciling Your Bank Statement
Reconcile your checking account and correct any data entry errors with the help of MoneyÆs tools.
Managing Money Files
Create or disable passwords, back up your data files, archive transactions, and restore your data after a crash.
Level 2
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
Adding New Accounts
Learn how to add accounts to track cash purchases, loans, investments, personal property, real estate, and credit cards.
Adding Loan Accounts
Add accounts to track the value of an asset against the amount owed. This can be useful for tracking equity in assets like a home or vehicle.
Managing Bills and Deposits
Stay on top of your bills and deposits with Money. Avoid making late payments and plan out your cash flow so you can keep your credit in good shape.
Categories and Payees
Manage your expenses to track your income and spending. Adapt and customize the categories in Money to suit your situation.
Generating Reports
Create reports and charts to show how you are spending your money, what you have, what you owe, and more.
Money and the Internet
Link your bank account to your Money file, set up electronic payments, and set up a Microsoft Passport to secure your data.
Online Banking
Submit electronic payments using MSN Bill Pay, download transactions from a linked account, and set preferences for how Money communicates with your bank.
Level 3
Introduction
We outline the topics and projects covered in the lessons, as well as what you will need to follow along.
Investment Accounts
Create a portfolio for keeping track of your investments. Track regular investment accounts as well as IRAs.
Managing Your Portfolio
Keep an eye on stocks you own as well as those you are thinking about investing in. Research stocks with the Stock Screener, company reports, and other Money tools.
The Money Advisor
Set account balance alerts, track your monthly discretionary spending on the Home Page, and use Advisor FYI. Sign up for customized MSN Alerts.
The Budget Planner
Learn how to fine tune your budget, save towards your goals, and set alerts for when you are close to exceeding a budget category.
The Lifetime Planner
Create a projection of your lifetime finances based on the information you have now. Then make changes to your plan to reach your retirement and other financial goals.
Tax Tools
Keep your finances organized to make tax time easier, whether you prepare your taxes by hand, file electronically, or export your data to a tax preparation software package.
END
Photoshop CS
Level 1
Introduction
A brief look at the topics and projects covered in this lesson, as well as what youÆll need to follow along.
The Photoshop Window
Become familiar with basic Photoshop features and learn where to easily access them.
Image Files
Understand resolution and how it affects image size and quality. Explore multiple methods of opening and saving files in different formats.
The File Browser
Discover the power of PhotoshopÆs browser. Use the browser to sort and manage images.
Creating New Files
Learn how to customize files by manipulating file size and resolution.
The Work Environment
Increase productivity by utilizing PhotoshopÆs View, Move, and Zoom functions.
The Photoshop Toolbox
Explore multiple toolbox features and how to access frequently used commands.
Working with Palettes
Study PhotoshopÆs multiple palettes and find out how theyÆre used to verify settings and manipulate images.
The Layers Palette
Use this powerful feature to efficiently separate and modify image data.
Managing Multiple Layers
Work with layers to discover shortcuts that will increase productivity while creating a practice image.
Level 2
Introduction
A brief look at the topics and projects covered in this lesson, as well as what youÆll need to follow along.
Photoshop Selections
Isolate and alter specific areas of an image with the help of PhotoshopÆs multiple selection features.
Transforming Images
Generate unique pictures by altering image size and location.
Advanced Compositing
Explore the different methods of building layered images while utilizing the power of Photoshop Channels.
Quick Mask Mode
Understand this invaluable Photoshop feature and use it to boost project efficiency.
Retouching Images
Restore aged or damaged photographs by removing defects and improving image contrast.
Working with Color
Discover effective methods to adjust and control color. Understand the potential of color manipulation.
Working with Text
Enhance images by creating and inserting customized text.
Vector Shapes
Build scalable shapes with vectors and recognize the multiple uses of adding effects to them.
Level 3
Introduction
A brief look at the topics and projects covered in this lesson, as well as what youÆll need to follow along.
Setting Preferences
Discover how altering PhotoshopÆs Preferences can increase project efficiency.
Color Management
Manipulate colors with image profiles and modes to see how they affect overall appearance.
Color Selection
Utilize PhotoshopÆs Color Picker while covering the significance of bit depth.
The Actions Palette
Save time and effort by creating a series of predetermined actions that can be applied to images later.
Automating Functions
Minimize repetitive tasks by setting up functions that can be performed by a single click.
Using Filters
Generate various effects with PhotoshopÆs numerous filters.
Rollovers and Image Maps
Divide and section a web page in order to maximize browser download speeds.
ImageReady« Animation
Use ImageReady to create and animate a graphic specifically for the Web.
Optimizing Web Graphics
Streamline a web page to make it easier to view on the Web.
